"192.168.0.1:sipop"

PRODUCTOS_AU

Descriptions

There is no desription for trigger PRODUCTOS_AU

Definition

CREATE TRIGGER PRODUCTOS_AU FOR PRODUCTOS ACTIVE
AFTER DELETE POSITION 0
AS
declare variable HIJO INTEGER;
BEGIN
  /* Trigger body */
  
   SELECT COUNT (ID_PRODUCTOS) FROM PRODUCTOS
   WHERE
           ID_PADRE_PRODUCTO = OLD.id_padre_producto
   INTO:HIJO;
  UPDATE PRODUCTOS SET HIJOS = :HIJO WHERE ID_PRODUCTOS = OLD.id_padre_producto;

END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.